Sorting Your Data

GVPT399F: Power, Politics, and Data

Arrange rows with arrange()

arrange(gapminder, country, year)
# A tibble: 1,704 × 6
   country     continent  year lifeExp      pop gdpPercap
   <fct>       <fct>     <int>   <dbl>    <int>     <dbl>
 1 Afghanistan Asia       1952    28.8  8425333      779.
 2 Afghanistan Asia       1957    30.3  9240934      821.
 3 Afghanistan Asia       1962    32.0 10267083      853.
 4 Afghanistan Asia       1967    34.0 11537966      836.
 5 Afghanistan Asia       1972    36.1 13079460      740.
 6 Afghanistan Asia       1977    38.4 14880372      786.
 7 Afghanistan Asia       1982    39.9 12881816      978.
 8 Afghanistan Asia       1987    40.8 13867957      852.
 9 Afghanistan Asia       1992    41.7 16317921      649.
10 Afghanistan Asia       1997    41.8 22227415      635.
# ℹ 1,694 more rows

Arrange rows with arrange()

arrange(gapminder, country, desc(year))
# A tibble: 1,704 × 6
   country     continent  year lifeExp      pop gdpPercap
   <fct>       <fct>     <int>   <dbl>    <int>     <dbl>
 1 Afghanistan Asia       2007    43.8 31889923      975.
 2 Afghanistan Asia       2002    42.1 25268405      727.
 3 Afghanistan Asia       1997    41.8 22227415      635.
 4 Afghanistan Asia       1992    41.7 16317921      649.
 5 Afghanistan Asia       1987    40.8 13867957      852.
 6 Afghanistan Asia       1982    39.9 12881816      978.
 7 Afghanistan Asia       1977    38.4 14880372      786.
 8 Afghanistan Asia       1972    36.1 13079460      740.
 9 Afghanistan Asia       1967    34.0 11537966      836.
10 Afghanistan Asia       1962    32.0 10267083      853.
# ℹ 1,694 more rows

Get the smallest or largest value in one line of code

slice_min(gapminder, lifeExp)
# A tibble: 1 × 6
  country continent  year lifeExp     pop gdpPercap
  <fct>   <fct>     <int>   <dbl>   <int>     <dbl>
1 Rwanda  Africa     1992    23.6 7290203      737.


slice_max(gapminder, lifeExp)
# A tibble: 1 × 6
  country continent  year lifeExp       pop gdpPercap
  <fct>   <fct>     <int>   <dbl>     <int>     <dbl>
1 Japan   Asia       2007    82.6 127467972    31656.